<html>
<head>
<META http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>HyperSQL User Guide</title>
<link href="../docbook.css" rel="stylesheet" type="text/css">
<meta content="DocBook XSL-NS Stylesheets V1.74.0" name="generator">
<meta name="keywords" content="Hsqldb, HyperSQL, Database, JDBC, Java">
<link rel="home" href="index.html" title="HyperSQL User Guide">
<link rel="next" href="book-pref.html" title="Preface">
</head>
<body bgcolor="white" text="black" link="#0000FF" vlink="#840084" alink="#0000FF">
<div class="navheader">
<table summary="Navigation header" width="100%">
<tr>
<th align="center" colspan="3">HyperSQL User Guide</th>
</tr>
<tr>
<td align="left" width="20%">&nbsp;</td><th align="center" width="60%">&nbsp;</th><td align="right" width="20%">&nbsp;<a accesskey="n" href="book-pref.html"><img src="../images/db/next.gif" alt="Next"></a></td>
</tr>
</table>
<hr>
</div>
<div class="book" lang="en">
<div class="titlepage">
<div>
<div>
<h1 class="title">
<a name="guide"></a>HyperSQL User Guide</h1>
</div>
<div>
<h2 class="subtitle">HyperSQL Database Engine, aka HSQLDB</h2>
</div>
<div>
<div class="authorgroup">
<div class="editor">
<h4 class="editedby">Edited by</h4>
<h3 class="editor">
<span class="orgname">The HSQL Development Group</span>
</h3>
</div>
<div class="editor">
<h4 class="editedby">Edited by</h4>
<h3 class="editor">
<span class="firstname">Blaine</span> <span class="surname">Simpson</span>
</h3>
<div class="affiliation">
<span class="orgname">The HSQL Development Group<br>
</span>
</div>
</div>
<div class="editor">
<h4 class="editedby">Edited by</h4>
<h3 class="editor">
<span class="firstname">Fred</span> <span class="surname">Toussi</span>
</h3>
<div class="affiliation">
<span class="orgname">The HSQL Development Group<br>
</span>
</div>
</div>
</div>
</div>
<div>
<p class="releaseinfo">$Revision: 3201 $</p>
</div>
<div>
<div class="legalnotice">
<a name="N10036"></a>
<p>Copyright 2002-2009 The HSQL Development Group. Permission is
      granted to distribute this document without any alteration under the
      terms of the HSQLDB license.</p>
</div>
</div>
<div>
<p class="pubdate">$Date: 2009-09-16 09:03:08 -0400 (Wed, 16 Sep 2009) $</p>
</div>
</div>
<hr>
</div>
<div class="toc">
<p>
<b>Table of Contents</b>
</p>
<dl>
<dt>
<span class="preface"><a href="book-pref.html">Preface</a></span>
</dt>
<dd>
<dl>
<dt>
<span class="section"><a href="book-pref.html#altformats-sect">Available formats for this document</a></span>
</dt>
</dl>
</dd>
<dt>
<span class="chapter"><a href="running-chapt.html">1. Running and Using HyperSQL</a></span>
</dt>
<dd>
<dl>
<dt>
<span class="section"><a href="running-chapt.html#running_jar-sect">The HSQLDB Jar</a></span>
</dt>
<dt>
<span class="section"><a href="running-chapt.html#running_tools-sect">Running Database Access Tools</a></span>
</dt>
<dt>
<span class="section"><a href="running-chapt.html#running_db-sect">A HyperSQL Database</a></span>
</dt>
<dt>
<span class="section"><a href="running-chapt.html#running_inprocess-sect">In-Process Access to Database Catalogs</a></span>
</dt>
<dt>
<span class="section"><a href="running-chapt.html#running_modes-sect">Listener / Server Modes</a></span>
</dt>
<dd>
<dl>
<dt>
<span class="section"><a href="running-chapt.html#running_hsqlserver-sect">HyperSQL HSQL Server</a></span>
</dt>
<dt>
<span class="section"><a href="running-chapt.html#running_httpserver-sect">HyperSQL HTTP Server</a></span>
</dt>
<dt>
<span class="section"><a href="running-chapt.html#running_servlet-sect">HyperSQL HTTP Servlet</a></span>
</dt>
<dt>
<span class="section"><a href="running-chapt.html#running_connecting-sect">Connecting to a Database Server</a></span>
</dt>
<dt>
<span class="section"><a href="running-chapt.html#running_security-sect">Security Considerations</a></span>
</dt>
<dt>
<span class="section"><a href="running-chapt.html#running_multiple_db-sect">Using Multiple Databases</a></span>
</dt>
</dl>
</dd>
<dt>
<span class="section"><a href="running-chapt.html#running-data-access-sect">Accessing the Data</a></span>
</dt>
<dt>
<span class="section"><a href="running-chapt.html#running_closing-sect">Closing the Database</a></span>
</dt>
<dt>
<span class="section"><a href="running-chapt.html#running_newdb-sect">Creating a New Database</a></span>
</dt>
</dl>
</dd>
<dt>
<span class="chapter"><a href="sqlgeneral-chapt.html">2. SQL Language</a></span>
</dt>
<dd>
<dl>
<dt>
<span class="section"><a href="sqlgeneral-chapt.html#sqlgeneral_standards-sect">Standards Support</a></span>
</dt>
<dt>
<span class="section"><a href="sqlgeneral-chapt.html#sqlgeneral_tabletypes-sect">SQL Data and Tables</a></span>
</dt>
<dd>
<dl>
<dt>
<span class="section"><a href="sqlgeneral-chapt.html#N10360">Temporary Tables</a></span>
</dt>
<dt>
<span class="section"><a href="sqlgeneral-chapt.html#N10365">Persistent Tables</a></span>
</dt>
<dt>
<span class="section"><a href="sqlgeneral-chapt.html#N1038C">Lob Data</a></span>
</dt>
</dl>
</dd>
<dt>
<span class="section"><a href="sqlgeneral-chapt.html#sqlgeneral_types_ops-sect">Basic Types and Operations</a></span>
</dt>
<dd>
<dl>
<dt>
<span class="section"><a href="sqlgeneral-chapt.html#N1039F">Numeric Types</a></span>
</dt>
<dt>
<span class="section"><a href="sqlgeneral-chapt.html#N10465">Boolean Type</a></span>
</dt>
<dt>
<span class="section"><a href="sqlgeneral-chapt.html#N1048B">Character String Types</a></span>
</dt>
<dt>
<span class="section"><a href="sqlgeneral-chapt.html#N104BA">Binary String Types</a></span>
</dt>
<dt>
<span class="section"><a href="sqlgeneral-chapt.html#N104D8">Bit String Types</a></span>
</dt>
<dt>
<span class="section"><a href="sqlgeneral-chapt.html#N104ED">Storage and Handling of Java Objects</a></span>
</dt>
<dt>
<span class="section"><a href="sqlgeneral-chapt.html#N1050C">Type Length, Precision and Scale</a></span>
</dt>
</dl>
</dd>
<dt>
<span class="section"><a href="sqlgeneral-chapt.html#N10527">Datetime types</a></span>
</dt>
<dt>
<span class="section"><a href="sqlgeneral-chapt.html#N1061B">Interval Types</a></span>
</dt>
<dt>
<span class="section"><a href="sqlgeneral-chapt.html#sqlgeneral_constr_indexes-sect">Indexes and Query Speed</a></span>
</dt>
<dt>
<span class="section"><a href="sqlgeneral-chapt.html#N106DF">Query Processing and Optimisation</a></span>
</dt>
</dl>
</dd>
<dt>
<span class="chapter"><a href="sessions-chapt.html">3. Sessions and Transactions</a></span>
</dt>
<dd>
<dl>
<dt>
<span class="section"><a href="sessions-chapt.html#N10712">Overview</a></span>
</dt>
<dt>
<span class="section"><a href="sessions-chapt.html#N10731">Session Attributes and Variables</a></span>
</dt>
<dd>
<dl>
<dt>
<span class="section"><a href="sessions-chapt.html#N10736">Session Attributes</a></span>
</dt>
<dt>
<span class="section"><a href="sessions-chapt.html#N10740">Session Variables</a></span>
</dt>
</dl>
</dd>
<dt>
<span class="section"><a href="sessions-chapt.html#sqlgeneral_trans_cc-sect">Transactions and Concurrency Control</a></span>
</dt>
<dd>
<dl>
<dt>
<span class="section"><a href="sessions-chapt.html#N10759">Two Phased Locking</a></span>
</dt>
<dt>
<span class="section"><a href="sessions-chapt.html#N1076A">Two Phased Locking with Snapshot Isolation</a></span>
</dt>
<dt>
<span class="section"><a href="sessions-chapt.html#N10773">Lock Contention in 2PL</a></span>
</dt>
<dt>
<span class="section"><a href="sessions-chapt.html#N1077E">MVCC</a></span>
</dt>
<dt>
<span class="section"><a href="sessions-chapt.html#N1078B">Choosing the Transaction Model</a></span>
</dt>
<dt>
<span class="section"><a href="sessions-chapt.html#N10798">Schema and Database Change</a></span>
</dt>
</dl>
</dd>
<dt>
<span class="section"><a href="sessions-chapt.html#N107A3">Session and Transaction Control Statements</a></span>
</dt>
</dl>
</dd>
<dt>
<span class="chapter"><a href="ch04.html">4. Schemas and Database Objects</a></span>
</dt>
<dd>
<dl>
<dt>
<span class="section"><a href="ch04.html#N109BA">Overview</a></span>
</dt>
<dt>
<span class="section"><a href="ch04.html#N109C5">Schemas and Schema Objects</a></span>
</dt>
<dd>
<dl>
<dt>
<span class="section"><a href="ch04.html#N109E4">Names and References</a></span>
</dt>
<dt>
<span class="section"><a href="ch04.html#N10A04">Character Sets</a></span>
</dt>
<dt>
<span class="section"><a href="ch04.html#N10A1E">Collations</a></span>
</dt>
<dt>
<span class="section"><a href="ch04.html#N10A2B">Distinct Types</a></span>
</dt>
<dt>
<span class="section"><a href="ch04.html#N10A32">Domains</a></span>
</dt>
<dt>
<span class="section"><a href="ch04.html#N10A39">Number Sequences</a></span>
</dt>
<dt>
<span class="section"><a href="ch04.html#N10A8F">Tables</a></span>
</dt>
<dt>
<span class="section"><a href="ch04.html#N10A9B">Views</a></span>
</dt>
<dt>
<span class="section"><a href="ch04.html#N10AB9">Constraints</a></span>
</dt>
<dt>
<span class="section"><a href="ch04.html#N10B12">Assertions</a></span>
</dt>
<dt>
<span class="section"><a href="ch04.html#N10B1C">Triggers</a></span>
</dt>
<dt>
<span class="section"><a href="ch04.html#N10B2A">Routines</a></span>
</dt>
<dt>
<span class="section"><a href="ch04.html#N10B43">Indexes</a></span>
</dt>
</dl>
</dd>
<dt>
<span class="section"><a href="ch04.html#N10B48">Statements for Schema Definition and Manipulation</a></span>
</dt>
<dd>
<dl>
<dt>
<span class="section"><a href="ch04.html#N10B4D">Common Elements and Statements</a></span>
</dt>
<dt>
<span class="section"><a href="ch04.html#N10BEA">Schema Creation</a></span>
</dt>
<dt>
<span class="section"><a href="ch04.html#N10C3B">Table Creation and Manipulation</a></span>
</dt>
<dt>
<span class="section"><a href="ch04.html#N10FAB">View Creation</a></span>
</dt>
<dt>
<span class="section"><a href="ch04.html#N10FF8">Domain Creation and Manipulation</a></span>
</dt>
<dt>
<span class="section"><a href="ch04.html#N1108D">Trigger Creation</a></span>
</dt>
<dt>
<span class="section"><a href="ch04.html#N11109">Routine Creation</a></span>
</dt>
<dt>
<span class="section"><a href="ch04.html#N111B1">Sequence Creation</a></span>
</dt>
<dt>
<span class="section"><a href="ch04.html#N1123B">SQL Procedure Statement</a></span>
</dt>
<dt>
<span class="section"><a href="ch04.html#N1125B">Other Schema Object Creation</a></span>
</dt>
</dl>
</dd>
<dt>
<span class="section"><a href="ch04.html#N11374">The Information Schema</a></span>
</dt>
<dd>
<dl>
<dt>
<span class="section"><a href="ch04.html#N1137F">Predefined Character Sets, Collations and Domains</a></span>
</dt>
<dt>
<span class="section"><a href="ch04.html#N1138A">Views in INFORMATION SCHEMA</a></span>
</dt>
</dl>
</dd>
</dl>
</dd>
<dt>
<span class="chapter"><a href="texttables-chapt.html">5. Text Tables</a></span>
</dt>
<dd>
<dl>
<dt>
<span class="section"><a href="texttables-chapt.html#texttables_overview-sect">Overview</a></span>
</dt>
<dt>
<span class="section"><a href="texttables-chapt.html#texttables_impl-sect">The Implementation</a></span>
</dt>
<dd>
<dl>
<dt>
<span class="section"><a href="texttables-chapt.html#N11457">Definition of Tables</a></span>
</dt>
<dt>
<span class="section"><a href="texttables-chapt.html#N11467">Scope and Reassignment</a></span>
</dt>
<dt>
<span class="section"><a href="texttables-chapt.html#N1147D">Null Values in Columns of Text Tables</a></span>
</dt>
<dt>
<span class="section"><a href="texttables-chapt.html#N11487">Configuration</a></span>
</dt>
<dt>
<span class="section"><a href="texttables-chapt.html#disconnecting_text_tables">Disconnecting Text Tables</a></span>
</dt>
</dl>
</dd>
<dt>
<span class="section"><a href="texttables-chapt.html#texttables_issues-sect">Text File Usage</a></span>
</dt>
<dt>
<span class="section"><a href="texttables-chapt.html#texttables_globalprops-sect">Text File Global Properties</a></span>
</dt>
<dt>
<span class="section"><a href="texttables-chapt.html#N1157C">Transactions</a></span>
</dt>
</dl>
</dd>
<dt>
<span class="chapter"><a href="accesscontrol-chapt.html">6. Access Control</a></span>
</dt>
<dd>
<dl>
<dt>
<span class="section"><a href="accesscontrol-chapt.html#N115A6">Overview</a></span>
</dt>
<dt>
<span class="section"><a href="accesscontrol-chapt.html#N115E6">Authorizations and Access Control</a></span>
</dt>
<dd>
<dl>
<dt>
<span class="section"><a href="accesscontrol-chapt.html#N11609">Built-In Roles and Users</a></span>
</dt>
<dt>
<span class="section"><a href="accesscontrol-chapt.html#N11662">Access Rights</a></span>
</dt>
</dl>
</dd>
<dt>
<span class="section"><a href="accesscontrol-chapt.html#N116A4">Statements for
    Authorization and Access Control</a></span>
</dt>
</dl>
</dd>
<dt>
<span class="chapter"><a href="ch07.html">7. Data Access and Change</a></span>
</dt>
<dd>
<dl>
<dt>
<span class="section"><a href="ch07.html#N11825">Overview</a></span>
</dt>
<dt>
<span class="section"><a href="ch07.html#N1182A">Cursors And Result Sets</a></span>
</dt>
<dd>
<dl>
<dt>
<span class="section"><a href="ch07.html#N11847">Columns and Rows</a></span>
</dt>
<dt>
<span class="section"><a href="ch07.html#N11862">Navigation</a></span>
</dt>
<dt>
<span class="section"><a href="ch07.html#N11874">Updatability</a></span>
</dt>
<dt>
<span class="section"><a href="ch07.html#N118B2">Sensitivity</a></span>
</dt>
<dt>
<span class="section"><a href="ch07.html#N118BB">Holdability</a></span>
</dt>
<dt>
<span class="section"><a href="ch07.html#N118CE">Autocommit</a></span>
</dt>
<dt>
<span class="section"><a href="ch07.html#N118D6">JDBC Overview</a></span>
</dt>
</dl>
</dd>
<dt>
<span class="section"><a href="ch07.html#N118E3">Syntax Elements</a></span>
</dt>
<dd>
<dl>
<dt>
<span class="section"><a href="ch07.html#N118E8">Literals</a></span>
</dt>
<dt>
<span class="section"><a href="ch07.html#N11A0E">References, etc.</a></span>
</dt>
<dt>
<span class="section"><a href="ch07.html#N11A6A">Value Expression</a></span>
</dt>
<dt>
<span class="section"><a href="ch07.html#N11C78">Predicates</a></span>
</dt>
<dt>
<span class="section"><a href="ch07.html#N11EAA">Other Syntax Elements</a></span>
</dt>
</dl>
</dd>
<dt>
<span class="section"><a href="ch07.html#N11F89">Data Access Statements</a></span>
</dt>
<dd>
<dl>
<dt>
<span class="section"><a href="ch07.html#N11FBE">Table</a></span>
</dt>
<dt>
<span class="section"><a href="ch07.html#N11FE4">Joined Table</a></span>
</dt>
<dt>
<span class="section"><a href="ch07.html#N12051">Selection</a></span>
</dt>
<dt>
<span class="section"><a href="ch07.html#N12056">Projection</a></span>
</dt>
<dt>
<span class="section"><a href="ch07.html#N1205D">Computed Columns</a></span>
</dt>
<dt>
<span class="section"><a href="ch07.html#N12062">Naming</a></span>
</dt>
<dt>
<span class="section"><a href="ch07.html#N120A4">Grouping Operations</a></span>
</dt>
<dt>
<span class="section"><a href="ch07.html#N120B2">Aggregation</a></span>
</dt>
<dt>
<span class="section"><a href="ch07.html#N120B9">Set Operations</a></span>
</dt>
<dt>
<span class="section"><a href="ch07.html#N120DD">Query Expression</a></span>
</dt>
<dt>
<span class="section"><a href="ch07.html#N120ED">Ordering</a></span>
</dt>
<dt>
<span class="section"><a href="ch07.html#N120FA">Slicing</a></span>
</dt>
</dl>
</dd>
<dt>
<span class="section"><a href="ch07.html#N12103">Data Change Statements</a></span>
</dt>
</dl>
</dd>
<dt>
<span class="chapter"><a href="sqlroutines-chapt.html">8. SQL-Invoked Routines</a></span>
</dt>
<dd>
<dl>
<dt>
<span class="section"><a href="sqlroutines-chapt.html#N12274">SQL Language Routines (PSM)</a></span>
</dt>
<dd>
<dl>
<dt>
<span class="section"><a href="sqlroutines-chapt.html#N122AE">Compound Statement</a></span>
</dt>
<dt>
<span class="section"><a href="sqlroutines-chapt.html#N122C0">Variables</a></span>
</dt>
<dt>
<span class="section"><a href="sqlroutines-chapt.html#N122D2">Handlers</a></span>
</dt>
<dt>
<span class="section"><a href="sqlroutines-chapt.html#N12300">Assignment Statement</a></span>
</dt>
<dt>
<span class="section"><a href="sqlroutines-chapt.html#N12316">Select Statement : Single Row</a></span>
</dt>
<dt>
<span class="section"><a href="sqlroutines-chapt.html#N12331">Formal Parameters</a></span>
</dt>
<dt>
<span class="section"><a href="sqlroutines-chapt.html#N1234C">Iterated Statements</a></span>
</dt>
<dt>
<span class="section"><a href="sqlroutines-chapt.html#N12363">Conditional Statements</a></span>
</dt>
<dt>
<span class="section"><a href="sqlroutines-chapt.html#N123AC">Return Statement</a></span>
</dt>
<dt>
<span class="section"><a href="sqlroutines-chapt.html#N123C7">Control Statements</a></span>
</dt>
<dt>
<span class="section"><a href="sqlroutines-chapt.html#N123E9">General SQL Statements</a></span>
</dt>
<dt>
<span class="section"><a href="sqlroutines-chapt.html#N123FD">Routine Overloading</a></span>
</dt>
</dl>
</dd>
<dt>
<span class="section"><a href="sqlroutines-chapt.html#N1240C">Java Language Routines (SQL/JRT)</a></span>
</dt>
<dt>
<span class="section"><a href="sqlroutines-chapt.html#N1249D">Routine Definition</a></span>
</dt>
</dl>
</dd>
<dt>
<span class="chapter"><a href="triggers-chapt.html">9. Triggers</a></span>
</dt>
<dd>
<dl>
<dt>
<span class="section"><a href="triggers-chapt.html#N12602">Overview</a></span>
</dt>
<dt>
<span class="section"><a href="triggers-chapt.html#N12626">Trigger Properties</a></span>
</dt>
<dd>
<dl>
<dt>
<span class="section"><a href="triggers-chapt.html#N1262B">Trigger Event</a></span>
</dt>
<dt>
<span class="section"><a href="triggers-chapt.html#N12634">Granularity</a></span>
</dt>
<dt>
<span class="section"><a href="triggers-chapt.html#N12643">Trigger Action Time</a></span>
</dt>
<dt>
<span class="section"><a href="triggers-chapt.html#N12650">References to Rows</a></span>
</dt>
<dt>
<span class="section"><a href="triggers-chapt.html#N12655">Trigger Condition</a></span>
</dt>
<dt>
<span class="section"><a href="triggers-chapt.html#N1265C">Trigger Action in SQL</a></span>
</dt>
<dt>
<span class="section"><a href="triggers-chapt.html#N12667">Trigger Action in Java</a></span>
</dt>
</dl>
</dd>
<dt>
<span class="section"><a href="triggers-chapt.html#N1267D">Trigger Creation</a></span>
</dt>
</dl>
</dd>
<dt>
<span class="chapter"><a href="builtinfunctions-chapt.html">10. Built In Functions</a></span>
</dt>
<dd>
<dl>
<dt>
<span class="section"><a href="builtinfunctions-chapt.html#builtin_functions_intro-sect">Overview</a></span>
</dt>
<dt>
<span class="section"><a href="builtinfunctions-chapt.html#builtin_functions_string-sect">String and Binary String Functions</a></span>
</dt>
<dt>
<span class="section"><a href="builtinfunctions-chapt.html#builtin_functions_numeric-sect">Numeric Functions</a></span>
</dt>
<dt>
<span class="section"><a href="builtinfunctions-chapt.html#builtin_functions_datetime-sect">Date Time and Interval Functions</a></span>
</dt>
<dt>
<span class="section"><a href="builtinfunctions-chapt.html#builtin_functions_sysfunc-sect">System Functions</a></span>
</dt>
</dl>
</dd>
<dt>
<span class="chapter"><a href="deployment-chapt.html">11. System Management and Deployment
  Issues</a></span>
</dt>
<dd>
<dl>
<dt>
<span class="section"><a href="deployment-chapt.html#deploymen_modes-sect">Mode of Operation and Tables</a></span>
</dt>
<dd>
<dl>
<dt>
<span class="section"><a href="deployment-chapt.html#N13051">Mode of Operation</a></span>
</dt>
<dt>
<span class="section"><a href="deployment-chapt.html#N1306A">Tables</a></span>
</dt>
<dt>
<span class="section"><a href="deployment-chapt.html#N1307F">Large Objects</a></span>
</dt>
<dt>
<span class="section"><a href="deployment-chapt.html#N13084">Deployment context</a></span>
</dt>
<dt>
<span class="section"><a href="deployment-chapt.html#N13090">Readonly Databases</a></span>
</dt>
</dl>
</dd>
<dt>
<span class="section"><a href="deployment-chapt.html#deployment_mem_disk-sect">Memory and Disk Use</a></span>
</dt>
<dd>
<dl>
<dt>
<span class="section"><a href="deployment-chapt.html#N130A5">Table Memory Allocation</a></span>
</dt>
<dt>
<span class="section"><a href="deployment-chapt.html#N130B3">Result Set Memory Allocation</a></span>
</dt>
<dt>
<span class="section"><a href="deployment-chapt.html#N130C6">Temporary Memory Use During Operations</a></span>
</dt>
<dt>
<span class="section"><a href="deployment-chapt.html#N130D2">Data Cache Memory Allocation</a></span>
</dt>
<dt>
<span class="section"><a href="deployment-chapt.html#N130EF">Object Pool Memory Allocation</a></span>
</dt>
<dt>
<span class="section"><a href="deployment-chapt.html#N130F7">Lob Memory Usage</a></span>
</dt>
</dl>
</dd>
<dt>
<span class="section"><a href="deployment-chapt.html#deployment_conns-sect">Managing Database Connections</a></span>
</dt>
<dt>
<span class="section"><a href="deployment-chapt.html#deployment_upgrade-sect">Upgrading Databases</a></span>
</dt>
<dd>
<dl>
<dt>
<span class="section"><a href="deployment-chapt.html#upgrade_via_script-sect">Upgrading From Older
      Versions</a></span>
</dt>
<dt>
<span class="section"><a href="deployment-chapt.html#N13164">Manual Changes to the *.script File</a></span>
</dt>
</dl>
</dd>
<dt>
<span class="section"><a href="deployment-chapt.html#N131A8">Compatibility Issues</a></span>
</dt>
<dt>
<span class="section"><a href="deployment-chapt.html#deployment_backup-sect">Backing Up Database Catalogs</a></span>
</dt>
<dd>
<dl>
<dt>
<span class="section"><a href="deployment-chapt.html#N131DA">Making Online Backups</a></span>
</dt>
<dt>
<span class="section"><a href="deployment-chapt.html#N131E9">Making Offline Backups</a></span>
</dt>
<dt>
<span class="section"><a href="deployment-chapt.html#N13206">Examining Backups</a></span>
</dt>
<dt>
<span class="section"><a href="deployment-chapt.html#N1321C">Restoring a Backup</a></span>
</dt>
</dl>
</dd>
<dt>
<span class="section"><a href="deployment-chapt.html#N13233">Encrypted Databases</a></span>
</dt>
<dd>
<dl>
<dt>
<span class="section"><a href="deployment-chapt.html#N1323A">Creating and Accessing an Encrypted Database</a></span>
</dt>
<dt>
<span class="section"><a href="deployment-chapt.html#N1324A">Speed Considerations</a></span>
</dt>
<dt>
<span class="section"><a href="deployment-chapt.html#N1324F">Security Considerations</a></span>
</dt>
</dl>
</dd>
<dt>
<span class="section"><a href="deployment-chapt.html#N13260">Monitoring Database Operations</a></span>
</dt>
<dd>
<dl>
<dt>
<span class="section"><a href="deployment-chapt.html#N13265">Statement Level Monitoring</a></span>
</dt>
<dt>
<span class="section"><a href="deployment-chapt.html#N1326E">Internal Event Monitoring</a></span>
</dt>
<dt>
<span class="section"><a href="deployment-chapt.html#N13279">Server Operation Monitoring</a></span>
</dt>
</dl>
</dd>
<dt>
<span class="section"><a href="deployment-chapt.html#N1327E">Statements</a></span>
</dt>
</dl>
</dd>
<dt>
<span class="chapter"><a href="dbproperties-chapt.html">12. Properties</a></span>
</dt>
<dd>
<dl>
<dt>
<span class="section"><a href="dbproperties-chapt.html#dbproperties_connections-sect">Connections</a></span>
</dt>
<dd>
<dl>
<dt>
<span class="section"><a href="dbproperties-chapt.html#conn_props-sect">Connection properties</a></span>
</dt>
</dl>
</dd>
<dt>
<span class="section"><a href="dbproperties-chapt.html#N13670">Database Properties in Connection URL and Properties</a></span>
</dt>
</dl>
</dd>
<dt>
<span class="chapter"><a href="listeners-chapt.html">13. HyperSQL Network Listeners</a></span>
</dt>
<dd>
<dl>
<dt>
<span class="section"><a href="listeners-chapt.html#listeners-sect">Listeners</a></span>
</dt>
<dd>
<dl>
<dt>
<span class="section"><a href="listeners-chapt.html#listeners_hsqlserver-sect">HyperSQL Server</a></span>
</dt>
<dt>
<span class="section"><a href="listeners-chapt.html#listeners_httpserver-sect">HyperSQL HTTP Server</a></span>
</dt>
<dt>
<span class="section"><a href="listeners-chapt.html#listeners_servlet-sect">HyperSQL HTTP Servlet</a></span>
</dt>
</dl>
</dd>
<dt>
<span class="section"><a href="listeners-chapt.html#listeners_server_props-sect">Server and Web Server Properties</a></span>
</dt>
<dt>
<span class="section"><a href="listeners-chapt.html#listeners_appstart-sect">Starting a Server from your application</a></span>
</dt>
<dt>
<span class="section"><a href="listeners-chapt.html#listeners_tls-sect">TLS Encryption</a></span>
</dt>
<dd>
<dl>
<dt>
<span class="section"><a href="listeners-chapt.html#N13A86">Requirements</a></span>
</dt>
<dt>
<span class="section"><a href="listeners-chapt.html#N13AA3">Encrypting your JDBC connection</a></span>
</dt>
<dt>
<span class="section"><a href="listeners-chapt.html#jsse-sect">JSSE</a></span>
</dt>
<dt>
<span class="section"><a href="listeners-chapt.html#privatekey-sect">Making a Private-key Keystore</a></span>
</dt>
<dt>
<span class="section"><a href="listeners-chapt.html#N13B87">Automatic Server or WebServer startup on UNIX</a></span>
</dt>
</dl>
</dd>
<dt>
<span class="section"><a href="listeners-chapt.html#listeners_acl-sect">Network Access Control</a></span>
</dt>
</dl>
</dd>
<dt>
<span class="chapter"><a href="unix-chapt.html">14. HyperSQL on UNIX</a></span>
</dt>
<dd>
<dl>
<dt>
<span class="section"><a href="unix-chapt.html#unix_purpose-sect">Purpose</a></span>
</dt>
<dt>
<span class="section"><a href="unix-chapt.html#unix_install-sect">Installation</a></span>
</dt>
<dt>
<span class="section"><a href="unix-chapt.html#unix_cat_setup-sect">Setting up Database Catalog and Listener</a></span>
</dt>
<dt>
<span class="section"><a href="unix-chapt.html#unix_access-sect">Accessing your Database</a></span>
</dt>
<dt>
<span class="section"><a href="unix-chapt.html#unix_addl_accts-sect">Create additional Accounts</a></span>
</dt>
<dt>
<span class="section"><a href="unix-chapt.html#unix_shutdown-sect">Shutdown</a></span>
</dt>
<dt>
<span class="section"><a href="unix-chapt.html#unix_daemon-sect">Running Hsqldb as a System Daemon</a></span>
</dt>
<dd>
<dl>
<dt>
<span class="section"><a href="unix-chapt.html#N13E54">Portability of hsqldb init script</a></span>
</dt>
<dt>
<span class="section"><a href="unix-chapt.html#N13E5E">Init script Setup Procedure</a></span>
</dt>
<dt>
<span class="section"><a href="unix-chapt.html#unix_inittrouble-sect">Troubleshooting the Init
      Script</a></span>
</dt>
</dl>
</dd>
<dt>
<span class="section"><a href="unix-chapt.html#unix_upgrade-sect">Upgrading</a></span>
</dt>
</dl>
</dd>
<dt>
<span class="appendix"><a href="lists-app.html">A. Lists of Keywords and SQL STATE
    Messages</a></span>
</dt>
<dd>
<dl>
<dt>
<span class="section"><a href="lists-app.html#N13F9F">List of SQL Standard Keywords</a></span>
</dt>
<dt>
<span class="section"><a href="lists-app.html#N13FD2">List of SQL Keywords Disallowed as HyperSQL Identifiers</a></span>
</dt>
</dl>
</dd>
<dt>
<span class="appendix"><a href="building-app.html">B. Building HyperSQL Jars</a></span>
</dt>
<dd>
<dl>
<dt>
<span class="section"><a href="building-app.html#N1402B">Purpose</a></span>
</dt>
<dt>
<span class="section"><a href="building-app.html#building-ant-sect">Building with Ant</a></span>
</dt>
<dd>
<dl>
<dt>
<span class="section"><a href="building-app.html#N14042">Obtaining Ant</a></span>
</dt>
<dt>
<span class="section"><a href="building-app.html#N14058">Building Hsqldb with Ant</a></span>
</dt>
<dt>
<span class="section"><a href="building-app.html#N140F8">Building for Older JDKs</a></span>
</dt>
</dl>
</dd>
<dt>
<span class="section"><a href="building-app.html#N14100">Building with IDE's</a></span>
</dt>
<dt>
<span class="section"><a href="building-app.html#N14105">Hsqldb CodeSwitcher</a></span>
</dt>
<dt>
<span class="section"><a href="building-app.html#N1412C">Building documentation</a></span>
</dt>
</dl>
</dd>
<dt>
<span class="appendix"><a href="openoffice-app.html">C. HyperSQL with OpenOffice.org</a></span>
</dt>
<dd>
<dl>
<dt>
<span class="section"><a href="openoffice-app.html#N14163">HyperSQL with OpenOffice.org</a></span>
</dt>
<dt>
<span class="section"><a href="openoffice-app.html#N1416A">Using OpenOffice.org as a Database Tool</a></span>
</dt>
<dt>
<span class="section"><a href="openoffice-app.html#N14177">Converting .odb files to use with HyperSQL Server</a></span>
</dt>
</dl>
</dd>
<dt>
<span class="appendix"><a href="apd.html">D. HyperSQL File Links</a></span>
</dt>
<dt>
<span class="index"><a href="sql-ind.html">SQL Index</a></span>
</dt>
<dt>
<span class="index"><a href="book-ind.html">General Index</a></span>
</dt>
</dl>
</div>
<div class="list-of-tables">
<p>
<b>List of Tables</b>
</p>
<dl>
<dt>1. <a href="book-pref.html#altformats-tbl">Available formats of this document</a>
</dt>
<dt>10.1. <a href="builtinfunctions-chapt.html#N12DC7">TO CHAR Values</a>
</dt>
<dt>12.1. <a href="dbproperties-chapt.html#N13531">HyperSQL URL Components</a>
</dt>
<dt>12.2. <a href="dbproperties-chapt.html#N135FB">Connection Properties</a>
</dt>
<dt>12.3. <a href="dbproperties-chapt.html#N13685">Database-specific Property File Properties</a>
</dt>
<dt>13.1. <a href="listeners-chapt.html#N1392F">common server and webserver properties</a>
</dt>
<dt>13.2. <a href="listeners-chapt.html#N139AB">server properties</a>
</dt>
<dt>13.3. <a href="listeners-chapt.html#N139DD">webserver properties</a>
</dt>
</dl>
</div>
<div class="list-of-examples">
<p>
<b>List of Examples</b>
</p>
<dl>
<dt>1.1. <a href="running-chapt.html#N1020F">Java code to connect to the local hsql Server</a>
</dt>
<dt>1.2. <a href="running-chapt.html#N10219">Java code to connect to the local http Server</a>
</dt>
<dt>1.3. <a href="running-chapt.html#N1023D">Java code to connect to the local secure SSL hsql and http
          Servers</a>
</dt>
<dt>1.4. <a href="running-chapt.html#N102E4">specifying a connection property to shutdown the database when
        the last connection is closed</a>
</dt>
<dt>1.5. <a href="running-chapt.html#N102FF">specifying a connection property to disallow creating a new
        database</a>
</dt>
<dt>3.1. <a href="sessions-chapt.html#N10745">User-defined Session Variables</a>
</dt>
<dt>3.2. <a href="sessions-chapt.html#N10814">Setting Transaction Characteristics</a>
</dt>
<dt>3.3. <a href="sessions-chapt.html#N1083E">Locking Tables</a>
</dt>
<dt>3.4. <a href="sessions-chapt.html#N108A1">Rollback</a>
</dt>
<dt>3.5. <a href="sessions-chapt.html#N108D3">Setting Session Characteristics</a>
</dt>
<dt>3.6. <a href="sessions-chapt.html#N108E9">Setting Session Authorization</a>
</dt>
<dt>3.7. <a href="sessions-chapt.html#N10916">Setting Session Time Zone</a>
</dt>
<dt>4.1. <a href="ch04.html#N10A53">inserting the next sequence value into a table row</a>
</dt>
<dt>4.2. <a href="ch04.html#N10A5A">numbering returned rows of a SELECT in sequential order</a>
</dt>
<dt>4.3. <a href="ch04.html#N10ADE">Column values which satisfy a 2-column UNIQUE
        constraint</a>
</dt>
<dt>11.1. <a href="deployment-chapt.html#N131EE">Offline Backup Example</a>
</dt>
<dt>11.2. <a href="deployment-chapt.html#N1320E">Listing a Backup with DbBackup</a>
</dt>
<dt>11.3. <a href="deployment-chapt.html#N13224">Restoring a Backup with DbBackup</a>
</dt>
<dt>13.1. <a href="listeners-chapt.html#N13AC3">Exporting certificate from the server's keystore</a>
</dt>
<dt>13.2. <a href="listeners-chapt.html#N13AD5">Adding a certificate to the client keystore</a>
</dt>
<dt>13.3. <a href="listeners-chapt.html#N13AE9">Specifying your own trust store to a JDBC client</a>
</dt>
<dt>13.4. <a href="listeners-chapt.html#N13B66">Getting a pem-style private key into a JKS keystore</a>
</dt>
<dt>13.5. <a href="listeners-chapt.html#N13BED">Validating and Testing an ACL file</a>
</dt>
<dt>14.1. <a href="unix-chapt.html#N13EB3">example sqltool.rc stanza</a>
</dt>
<dt>B.1. <a href="building-app.html#N140F1">Buiding the standard Hsqldb jar file with Ant</a>
</dt>
<dt>B.2. <a href="building-app.html#N1410E">Example source code before CodeSwitcher is run</a>
</dt>
<dt>B.3. <a href="building-app.html#N14115">CodeSwitcher command line invocation</a>
</dt>
<dt>B.4. <a href="building-app.html#N1411F">Source code after CodeSwitcher processing</a>
</dt>
</dl>
</div>
</div>
<HR xmlns:xi="http://www.w3.org/2001/XInclude">
<P xmlns:xi="http://www.w3.org/2001/XInclude" class="svnrev">$Revision: 3201 $</P>
<div class="navfooter">
<hr>
<table summary="Navigation footer" width="100%">
<tr>
<td align="left" width="40%">&nbsp;</td><td align="center" width="20%">&nbsp;</td><td align="right" width="40%">&nbsp;<a accesskey="n" href="book-pref.html"><img src="../images/db/next.gif" alt="Next"></a></td>
</tr>
<tr>
<td valign="top" align="left" width="40%">&nbsp;</td><td align="center" width="20%">&nbsp;</td><td valign="top" align="right" width="40%">&nbsp;Preface</td>
</tr>
</table>
</div>
</body>
</html>
